CREATE TABLE public.student (
                                id int8 NULL,
                                "name" varchar(128) NULL,
                                curriculum_id varchar NULL
);


-- 查询所有临时表
SELECT *
FROM pg_tables
WHERE schemaname like 'pg_temp%';

-- 事务级别的临时表
begin;
CREATE TEMPORARY TABLE pg_temp.temp_table_dfdfd (id varchar) ON COMMIT DROP;
select * from temp_table_dfdfd;
commit;


-- 查看所有连接
SELECT *
FROM pg_stat_activity where datname like '%demo%';